-- Table migration from FireBoard (any version)

-- NOTE: if you run the script manually some queries may fail on older versions
-- but it doesn't matter as update queries will add the missing tables..

-- FireBoard 1.0.0+
CREATE TABLE	`#__kunena_announcement`	SELECT * FROM #__fb_announcement;
ALTER TABLE		`#__kunena_announcement`	CHARACTER SET utf8

CREATE TABLE	`#__kunena_attachments`		SELECT * FROM #__fb_attachments;
ALTER TABLE		`#__kunena_attachments`		CHARACTER SET utf8

CREATE TABLE	`#__kunena_categories`		SELECT * FROM #__fb_categories;
ALTER TABLE		`#__kunena_categories`		CHARACTER SET utf8

CREATE TABLE	`#__kunena_favorites`		SELECT * FROM #__fb_favorites;
ALTER TABLE		`#__kunena_favorites`		CHARACTER SET utf8

CREATE TABLE	`#__kunena_messages`		SELECT * FROM #__fb_messages;
ALTER TABLE		`#__kunena_messages`		CHARACTER SET utf8

CREATE TABLE	`#__kunena_messages_text`	SELECT * FROM #__fb_messages_text;
ALTER TABLE		`#__kunena_messages_text`	CHARACTER SET utf8

CREATE TABLE	`#__kunena_moderation`		SELECT * FROM #__fb_moderation;
ALTER TABLE		`#__kunena_moderation`		CHARACTER SET utf8

CREATE TABLE	`#__kunena_sessions`		SELECT * FROM #__fb_sessions;
ALTER TABLE		`#__kunena_sessions`		CHARACTER SET utf8

CREATE TABLE	`#__kunena_smileys`			SELECT * FROM #__fb_smileys;
ALTER TABLE		`#__kunena_smileys`			CHARACTER SET utf8

CREATE TABLE	`#__kunena_subscriptions`	SELECT * FROM #__fb_subscriptions;
ALTER TABLE		`#__kunena_subscriptions`	CHARACTER SET utf8

CREATE TABLE	`#__kunena_users`			SELECT * FROM #__fb_users;
ALTER TABLE		`#__kunena_users`			CHARACTER SET utf8

CREATE TABLE	`#__kunena_whoisonline`		SELECT * FROM #__fb_whoisonline;
ALTER TABLE		`#__kunena_whoisonline`		CHARACTER SET utf8

-- FireBoard 1.0.1+
CREATE TABLE	`#__kunena_groups`			SELECT * FROM #__fb_groups;
ALTER TABLE		`#__kunena_groups`			CHARACTER SET utf8

-- FireBoard 1.0.3+
CREATE TABLE	`#__kunena_ranks`			SELECT * FROM #__fb_ranks;
ALTER TABLE		`#__kunena_ranks`			CHARACTER SET utf8

-- FireBoard 1.0.5RC1+
CREATE TABLE	`#__kunena_version`			SELECT * FROM #__fb_version;
ALTER TABLE		`#__kunena_version`			CHARACTER SET utf8
